Prescription Rate Data

The data we used to determine the prescription rate for each state comes from the CDC’s website. It includes data for each state - and summary data for the entire US - for overall opioid prescription doses and opioid prescription rate (per 100 persons) for the years 2006 - 2018. Although the data contained 12 years worth of prescribing information, we only used 2014 - 2018 because of the availability of matching overdose data.

Overdose Rate Data

The data we used to find the Overdose Rate also came from the CDC’s website. It includes overdose data from each state with columns that include, state name, death rate range, age adjusted overdose rate, and total number of overdose deaths. Age adjusted rate can be define as the death rate that controls for the effects of differences in population age distributions.

Analysis

In the first maps we can see how the prescription rate for opioids has changed from 2014 to 2018. It’s clear that policies instituted by the FDA in the late 2000s have come into effect, where nearly every state has lowered their prescription rate for opiates each year. Some interesting states to highlight include Alabama and West Virginia with prescription rates of 126 and 135 respectively per one hundred persons in 2014. These two states are on the higher end of the prescription rates in the US and later we can look into how this could play a roll in the overdose rates in both these states.

The next graphs are the Overdose rates per state from 2014 to 2018. Here we can see that overdoses have been substantially increasing each year since 2014. What’s interesting here is that many states with high prescription rates also have very high overdose rates which alludes to the possibility that prescription rate may contribute to the overdose rate in a state. West Virginia is known for having the worst opioid problem in the United States and the overdose rate here increases from 35.5 to 51.5 over the five year span. The opioid crisis is getting worse every year however, if states continue to keep lowering their prescription rates perhaps this can help to solve the problem.

Determining the Optimal K

While oftentimes you have to determine the optimal k for k-means clustering yourself, we wrote code to determine it for you. We determined the optimal k by selecting the largest mean silhouette score. The silhouette coefficient is a measure of how similar an observation is to its own cluster compared to other clusters. The values range from -1 (samples are assigned to the wrong cluster) to 1 (best possible value). The function below runs k-mean clustering on a given k, and then calculates mean silhouette score using the silhouette function from the cluster package. We are providing k inputs from 2-5, and then searching for the largest value.

# Helper function to calculate mean silhouette coefficient
silhouette_score <- function(k, full_data){
  km <- kmeans(full_data[, 2:3], centers = k, nstart = 20)
  score <- cluster::silhouette(km$cluster, dist(full_data[, 2:3]))
  mean(score[, 3])
}

# Follow up code to get the maximum silhouette coefficient
k <- 2:5
# Apply the helper function for k values of 2-5
avg_sil <- sapply(k, silhouette_score)
# Add 1 because data frame rows are from 1-4 and we put in 2-5
optimal_k <- which(as.data.frame(avg_sil)$avg_sil == max(avg_sil)) + 1

Analysis

In the clustering graph, states in the top right quadrant are classified as high risk for an opioid crisis. In these states, individuals are prescribed opioid/narcotic prescriptions at a higher rate and are also overdosing at greater proportions. Conversely, states in the bottom left quadrant are classified as low risk as they have low prescription and overdose rates. Geographically, southern states (i.e. Alabama, Louisiana, Tennessee, Mississippi, etc.) tend to cluster together. The same trend was evident in midwestern states (North and South Dakota, Minnesota, Nebraska, etc.). This suggests that states with geographic commonalities also share similar risks of opioid crises. These states that are identified as high risk can also be targeted for public policies, as physicians should be urged to prescribe opioids much more conservatively.

Answering Questions

1. How do prescription rates affect overdose rates in every state?

Looking at each year individually, it’s clear that the states with the highest prescription rates also have the highest overdose rates. Given our prescription rate maps and overdose rate maps along with the linear regression model, it’s fair to say that there is some correlation between the states with the highest prescription rates and the states with the highest overdose rate. If you take a look at the beginning of the the opioid epidemic, it initially started when doctors began to over prescribe opioids as pain medication. As more prescriptions were written, the problem slowly got out of hand and led to hundreds of thousands of Americans becoming addicted to opiates. When the FDA finally decided to more heavily regulate opioid prescriptions, the cat was already out of the bag and we now have an epidemic on our hands.

2. Which states seem to have been most impacted by the opioid crisis?

Throughout 2014-2018, the states most strongly impacted by the opioid epidemic are primarily located across the east and south-eastern United States. In particular, southern states are consistently grouped together as high risk (with high rates of prescriptions and overdoses). Notably, West Virginia was constantly among the highest risk states.

It is interesting to note that the general pattern of high risk states located in the east and south east US reflects numerous current public health trends. More specifically, the distribution of several cardiovascular diseases follows almost the same distribution as seen here. For example, the “Stroke Belt,” (pictured below) was recognized by public health officials as presenting notably high incidence of stroke. While the graphic displays data from the 2000s, this same trend has been documented repeatedly over the past two decades. This sweeping pattern of poor health across the east-to-south-east US has also been reported in other conditions, such as obesity. This general trend suggests that perhaps the same factors that are instrumental to the poor health of these states are also contributing to their classification as high risk for an opioid crisis.

Image of stroke belt - https://www.cdc.gov/stroke/maps_data.htm

3. What other factors could potentially contribute to high overdose rates other than prescription rates that we haven’t explored?

Prescription rates aren’t the only factor contributing to overdose rates throughout the United State. Other factors such as naloxone availiblity, poverty, access to hospitals could absolutely play a role in contributing to overdose rates in the US.

Next Steps

We think next steps for our project could include going down to the county level and further exploring the opioid crisis from there. Looking into the county level crisis could allow us to highlight where the problems are the most potent in each state. For example, identifying which counties are mostly affected by the epidemic could help the state in providing funds and aid to the counties in need. Here’s a look into what a map of prescription rates in West Virginia would look like if we continued with our next steps.

Other next steps could include analyzing more variables we believe could potentially contribute to the ever increasing severity of the opioid epidemic in the United States.